The figure shows the following SQLCA variables:

- SQLCAID Character string "SQLCA"

- SQLCABC Length of SQLCA data structure in bytes

- SQLCODE Oracle error message code

- SQLERRM Subrecord for storing error message

- SQLERRMC Text of error message

- SQLERRP Reserved for future use

- SQLERRD Array of six integer status codes

- SQLERRD(1) Reserved for future use

- SQLERRD(2) Reserved for future use

- SQLERRD(3) Number of rows processed

- SQLERRD(4) Reserved for future use

- SQLERRD(5) Parse error offset

- SQLERRD(6) Reserved for future use

- SQLWARN Array of eight warning flags

- SQLWARN(0) Another warning flag set

- SQLWARN(1) Character string truncated

- SQLWARN(2) no longer in use

- SQLWARN(3) SELECT list not equal to INTO list

- SQLWARN(4) DELETE or UPDATE without WHERE clause

- SQLWARN(5) Reserved for future use

- SQLWARN(6) No longer in use

- SQLWARN(7) No longer in use

- SQLEXT Reserved for future use